Columns description

  1. url contains the url of the restaurant in the zomato website

  2. address contains the address of the restaurant in Bengaluru

  3. name contains the name of the restaurant

  4. online_order whether online ordering is available in the restaurant or not

  5. book_table table book option available or not

  6. rate contains the overall rating of the restaurant out of 5

  7. votes contains total number of rating for the restaurant as of the above mentioned date

  8. phone contains the phone number of the restaurant

  9. location contains the neighborhood in which the restaurant is located

  10. rest_type restaurant type

  11. dish_liked dishes people liked in the restaurant

  12. cuisines food styles, separated by comma

  13. approx_cost(for two people) contains the approximate cost for meal for two people

  14. reviews_list list of tuples containing reviews for the restaurant, each tuple

  15. menu_item contains list of menus available in the restaurant

  16. listed_in(type) type of meal

  17. listed_in(city) contains the neighborhood in which the restaurant is listed

getting all NAN features

calculate avg rating of each resturant

Rating distribution
Almost more than 50 percent of restaurants has rating between 3 and 4. Restaurants having rating more than 4.5 are very rare.

Which are the top restaurant chains in Bangaluru?

How many of the restuarants do not accept online orders?
using plotly, How many of the restuarants do not accept online orders?

What is the ratio b/w restaurants that provide and do not provide table booking ?

How many types of restaurants we have?

now using plotly

At all, Banglore is known as the tech capital of India,people having busy and modern life will prefer Quick Bites.

highest voted restaurant

total restaurants at different locations of Bengalore

Total number of variety of restaurants ie north indian,south Indian

We can observe that North Indian,chinese,South Indian and Biriyani are most common.

It means Bengalore is more influenced by North Indian culture more than South

Analyse Approx cost for 2 people

cost vs rating

from this scattterplot,we can come up with a conclusion THAT most of the highest rated restaurants accepts online order and they are in budget

Is there any difference b/w price of restaurants accepting and not accepting online orders?

Restaurants accepting online orders are more affordable than Restaurants who are accepting online orders

Cheapest Rate for 2 people

Most costly for 2 people

distribution of cost for 2 people
most of the price lies between in a range of under 1000,it means most are affordable & very few are luxurious

Most costly Rate for 2 people is served at which Restaurant what exactly is the dish involved in this and liked dish of that restaurant

Top 10 Most Expensive restaurant with approx cost for 2 people

Top 10 Cheapest restaurant with approx cost for 2 people

all the restautant that are below than 500(budget hotel)

Total no. of Restaurants that have better rating >4 and that are under budget too ie less than 500

Total such various affordable hotels at different location

To Visualise what are the names of those hotels

Finding Best budget Restaurants in any location

we will pass location and restaurant type as parameteres,function will return name of restaurants.

Which are the foodie areas?

We can see that BTM,HSR and Koranmangala 5th block has the most number of restaurants.

BTM dominates the section by having more than 4000 restaurants.

geographical analysis

I need Latitudes & longitudes for each of the place for geaographical Data analysis,so to fetch lat,lon of each place,use Geopy

We have found out latitude and longitude of each location listed in the dataset using geopy.
This is used to plot maps.
now combine both the dataframes
It is clear that restaurants tend to concentrate in central bangalore area.

The cluster of restaurants lowers are we move away from central.

note heatmap is good when we have latitude,longitude or imporatnce of that particular place or count of that place

Heatmap of North Indian restaurants

What about South Indian cuisines?
analysing Reviews of Particular Restaurant
remove multiple spaces

analyse review of a particular restaurant